<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Block</title>
</head>

<body>
<?php
include("../connection/connection.php");
include("reportFunctions.php");
$distId=$_REQUEST['distId'];
?>

<table border="0" width="800" cellspacing="0" cellpadding="0">
	<tr>
		<td bgcolor="#E9E9E9" height="26">
		<p align="center"><span style="font-size: 9pt; font-weight: 700">
		<font face="Verdana" color="#224568">Comparison of Number of Schemes 
		between PHED and Field Survey</font></span></td>
	</tr>
	<tr>
	  <td bgcolor="#E9E9E9" height="26"><div align="center"><font face="Verdana" style="font-size: 9pt; font-weight: 700" color="#224568">Table 2 </font></div></td>
  </tr>
	<tr>
		<td bgcolor="#E9E9E9" height="56">
		<table border="1" width="800" cellspacing="0" cellpadding="0" height="61" bgcolor="#C5D8EB">
			<tr>
				<td width="40" rowspan="2" align="center">
				<p align="center"><font face="Verdana" style="font-size: 8.5pt">
				S. No.</font></td>
				<td width="200" rowspan="2" align="center">
				<font face="Verdana" style="font-size: 8.5pt">Name of the Scheme</font></td>
				<td width="235" align="center" colspan="2">
				<p align="center"><font style="font-size: 8.5pt" face="Verdana">
				Number of RWS Scheme</font></td>
				<td align="center" rowspan="2">
				<p align="center"><font face="Verdana" style="font-size: 8.5pt">
				Remarks</font></td>
			</tr>
			<tr>
				<td width="118" align="center" height="28">
				<font style="font-size: 8.5pt" face="Verdana">As per the Survey</font></td>
				<td width="115" align="center" height="28">
				<font style="font-size: 8.5pt" face="Verdana">As per PHED</font></td>
			</tr>
		</table>		</td>
	</tr>
	<tr>
		<td>
		<table border="1" width="800" cellspacing="0" cellpadding="0" height="49" bordercolor="#C5D8EB" style="border: 1px solid #BBD1E8" bgcolor="#F9F9F9">
			<tr>
				<td width="39" align="center"><font face="Verdana" style="font-size: 8.5pt">1</font></td>
				<td width="200" align="center"><font face="Verdana" style="font-size: 8.5pt">Piped Scheme</font></td>
				<td width="118" align="center"><font face="Verdana" style="font-size: 8.5pt">&nbsp;</font></td>
				<td width="117" align="center"><font face="Verdana" style="font-size: 8.5pt"><?php echo getSchemeNoDistWise($distId,'piped'); ?></font></td>
				<td align="center"><font face="Verdana" style="font-size: 8.5pt">&nbsp;</font></td>
			</tr>
			<tr>
				<td width="39" align="center"><font face="Verdana" style="font-size: 8.5pt">2</font></td>
				<td width="200" align="center"><font face="Verdana" style="font-size: 8.5pt">P&amp;T Scheme</font></td>
				<td width="118" align="center"><font face="Verdana" style="font-size: 8.5pt">&nbsp;</font></td>
				<td width="117" align="center"><font face="Verdana" style="font-size: 8.5pt"><?php echo getSchemeNoDistWise($distId,'P&T'); ?></font></td>
				<td align="center"><font face="Verdana" style="font-size: 8.5pt">&nbsp;</font></td>
			</tr>
			<tr>
				<td width="39" align="center"><font face="Verdana" style="font-size: 8.5pt">3</font></td>
				<td width="200" align="center"><font face="Verdana" style="font-size: 8.5pt">Regional WSS</font></td>
				<td width="118" align="center"><font face="Verdana" style="font-size: 8.5pt">&nbsp;</font></td>
				<td width="117" align="center"><font face="Verdana" style="font-size: 8.5pt"><?php echo "0";//getSchemeNoBlockWise($distId,'piped',$rowReport['block_id']); ?></font></td>
				<td align="center"><font face="Verdana" style="font-size: 8.5pt">&nbsp;</font></td>
			</tr>
			<tr>
				<td width="39" align="center"><font face="Verdana" style="font-size: 8.5pt">4</font></td>
				<td width="200" align="center"><font face="Verdana" style="font-size: 8.5pt">HP</font></td>
				<td width="118" align="center"><font face="Verdana" style="font-size: 8.5pt">&nbsp;</font></td>
				<td width="117" align="center"><font face="Verdana" style="font-size: 8.5pt"><?php echo getSchemeNoDistWise($distId,'HP'); ?></font></td>
				<td align="center"><font face="Verdana" style="font-size: 8.5pt">&nbsp;</font></td>
			</tr>
			
			<?php
			$piped=getSchemeNoDistWise($distId,'piped');
			$pt=getSchemeNoDistWise($distId,'P&T');
			$hp=getSchemeNoDistWise($distId,'HP');
			$totalschemes+=$piped;
			$totalschemes+=$pt;
			$totalschemes+=$hp;
			?>
			<tr>
				<td width="39" align="center" bgcolor="#BBD1E8"><font face="Verdana" style="font-size: 8.5pt">&nbsp;</font></td>
				<td width="200" align="center" bgcolor="#BBD1E8">
				<font style="font-size: 8.5pt" face="Verdana">Total</font></td>
				<td width="118" align="center" bgcolor="#BBD1E8">&nbsp;</font></td>
				<td width="117" align="center" bgcolor="#BBD1E8"><font face="Verdana" style="font-size: 8.5pt"><?php echo $totalschemes;?></font></td>
				<td align="center" bgcolor="#BBD1E8">&nbsp;</font></td>
			</tr>
		</table>		</td>
	</tr>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>


</body>

</html>